Creating Interviewer Activity - Page 3 of the dashboard
22
Creating Interviewer Activity - Page 3 of the dashboard
Duplicate the KPI Overview page and delete everything except the Interviewer NPS and Interviewer Score KPI cards and rename the page to Interviewer Activity. Then change the name in the text box as Interviewer Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields 
- Select the scattered plot icon from the visualization panel.
- Select Interviewer from Interviewer Dim table to Details
- Select Interviewer Score from the Measure table to X-Axis
- Select Interviewer NPS from Measure table to Y-Axis
- Select Interviews Per Day from Measure table to Size
- Select Year Month from Date table to Play Axis
- Select Interviewee from Interviewee Dim table to Tooltips.
Step 2: In Format Tool. 
- X axis
- Start 1, End 1
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Everything else remains the same.
- Y axis
- Start 20, End 120
- Everything else same as above (X axis)
- Data Color:
- Format by - Field value
- Based on field - InterviewerScattereColor from the Measure table.
- Category ON
- Title ON and renamed to Interview NPS and Score by Interviewer.
- Background ON
- Color - White, and Transparency - 0
- Tooltip ON
- Visual header ON




Step 3: In Analytics 
- X-Axis Constant Line 1 click + add
- Value 0.9
- Transparency 50
- Line style - Dashed
- Position - In front
- Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months
- Select Filters panel.
- Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
- On the Filter type, select Basic filtering and select 1
after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.

When you click on the play axis button you can pause it to see the values in monthly basis also.

Scatter chats and bubble charts in power bi
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
Creating Interviewer Activity - Page 3 of the dashboard
22
Creating Interviewer Activity - Page 3 of the dashboard
Duplicate the KPI Overview page and delete everything except the Interviewer NPS and Interviewer Score KPI cards and rename the page to Interviewer Activity. Then change the name in the text box as Interviewer Activity Dashboard, and move the colaberry logo to top left side and align it as shown in the screenshot below.

Creating Scattered Plot:

Step 1: In Fields 
- Select the scattered plot icon from the visualization panel.
- Select Interviewer from Interviewer Dim table to Details
- Select Interviewer Score from the Measure table to X-Axis
- Select Interviewer NPS from Measure table to Y-Axis
- Select Interviews Per Day from Measure table to Size
- Select Year Month from Date table to Play Axis
- Select Interviewee from Interviewee Dim table to Tooltips.
Step 2: In Format Tool. 
- X axis
- Start 1, End 1
- Text size 9
- Font Family - Segoe UI
- Title text size - 12
- Everything else remains the same.
- Y axis
- Start 20, End 120
- Everything else same as above (X axis)
- Data Color:
- Format by - Field value
- Based on field - InterviewerScattereColor from the Measure table.
- Category ON
- Title ON and renamed to Interview NPS and Score by Interviewer.
- Background ON
- Color - White, and Transparency - 0
- Tooltip ON
- Visual header ON




Step 3: In Analytics 
- X-Axis Constant Line 1 click + add
- Value 0.9
- Transparency 50
- Line style - Dashed
- Position - In front
- Y-Axis Constant Line 1 click + add
- Value 55
- Everything else same as above (X-Axis)

Step 4: Adding the Rolling 12Months
- Select Filters panel.
- Drag and drop Rolloing12Month from the Date table to the area that says "Add data fields here" as shown in the screenshot.
- On the Filter type, select Basic filtering and select 1
after that go to filter pane click on expand button next to the Interviewer, select basic filtering, click on select all and then uncheck (Blank) as shown in the screenshot to avoid blanks in the report.

When you are done putting all these together, you will have something like this.

When you click on the play axis button you can pause it to see the values in monthly basis also.

Scatter chats and bubble charts in power bi
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter